/*
Navicat Oracle Data Transfer
Oracle Client Version : 10.2.0.1.0

Source Server         : Lifting
Source Server Version : 100200
Source Host           : localhost:1521
Source Schema         : LIFTING

Target Server Type    : ORACLE
Target Server Version : 100200
File Encoding         : 65001

Date: 2014-09-23 15:08:08
*/


-- ----------------------------
-- Table structure for "LIFTING"."T_NOMINASI_KKKS"
-- ----------------------------
DROP TABLE "LIFTING"."T_NOMINASI_KKKS";
CREATE TABLE "LIFTING"."T_NOMINASI_KKKS" (
"ID" NUMBER NULL ,
"ID_KPS" NVARCHAR2(50) NULL ,
"TAHUN" NUMBER(5) NULL ,
"BULAN" NUMBER(2) NULL ,
"TANGGAL" DATE NULL ,
"NOMINASI" FLOAT NULL ,
"LOCKED" NUMBER(2) DEFAULT 0  NULL ,
"I_USER" VARCHAR2(50 BYTE) NULL ,
"I_DATE" TIMESTAMP(6)  NULL ,
"U_USER" VARCHAR2(50 BYTE) NULL ,
"U_DATE" TIMESTAMP(6)  NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_NOMINASI_KKKS
-- ----------------------------

-- ----------------------------
-- Triggers structure for table "LIFTING"."T_NOMINASI_KKKS"
-- ----------------------------
CREATE OR REPLACE TRIGGER "LIFTING"."TRIG_NOMINASI_KKKS" BEFORE INSERT ON "LIFTING"."T_NOMINASI_KKKS" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
BEGIN
SELECT SEQ_NOMINASI_KKKS.nextval INTO :NEW.ID FROM dual;
END;;
